select * from Pupil

--Get Students data whose age is less than 8 AND grade is LKG
select * from Pupil where Age < 8 and Grade = 'LKG';

--Get Students data -either age is lessa than 8 OR grade is LKG
select * from Pupil where Age < 8 or Grade = 'LKG';

--Get students data whose age is in the range of 4 - 6 years.
select * from Pupil  where Age = 4 and Age = 5 and Age = 6;--Incorrect
select * from Pupil where Age = 4 or Age = 5 or Age = 6;--Correct

--Getting studetns data on the basis of Age range.
select * from Pupil where Age between 4 and 6;

--Getting students data whose age is either 4 or 8.
select * from pupil where age = 4 or age = 8; --Correct
select * from pupil where age = 4 and age = 8; --Incorrect

--Rewriting above query using in operator
select * from pupil where age in (4,8)

--Getting students data whose age is not 4 years
select * from pupil where age <> 4;

--Getting students data whose age is not 4 and 6 years.
select * from pupil where age <> 4 and age <> 6; --Correct
select * from pupil where age <> 4 or age <> 6;	--Incorrect

--Rewriting above query
select * from pupil where age not in (4,6)

--Getting students data whose age range is not between 5 - 8 years
select * from pupil where age not between 5 and 8